﻿<%@ Page Language="C#" MasterPageFile="~/Teacher/TeacMasterPage.master" AutoEventWireup="true" CodeFile="Papers.aspx.cs" Inherits="Teacher_Default3" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentBody" Runat="Server">
试卷管理<form runat="server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
            <asp:BoundField DataField="Expr1" HeaderText="Expr1" SortExpression="Expr1" />
            <asp:BoundField DataField="date" HeaderText="date" SortExpression="date" />
            <asp:BoundField DataField="Expr2" HeaderText="Expr2" SortExpression="Expr2" />
            <asp:BoundField DataField="finishedMinutes" HeaderText="finishedMinutes" SortExpression="finishedMinutes" />
            <asp:BoundField DataField="totalScore" HeaderText="totalScore" SortExpression="totalScore" />
            <asp:HyperLinkField HeaderText="添加试题" DataTextField="id" DataNavigateUrlFormatString="AddQuestionsToPaper.aspx?paperId={0}" DataTextFormatString="添加试题" DataNavigateUrlFields="id" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:onlineexamConnectionString %>"
        SelectCommand="SELECT t_paper.id,t_paper.name, t_course.name AS Expr1, t_paper.date, t_teacher.name AS Expr2, t_paper.finishedMinutes, t_paper.totalScore FROM t_paper INNER JOIN t_teacher ON t_paper.teacherId = t_teacher.id INNER JOIN t_course ON t_teacher.courseId = t_course.id" >
    </asp:SqlDataSource>
    <br />
    <br />
    <a href="AddPaper.aspx">添加一张试卷</a><br />


</form>
</asp:Content>

